SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE Addin.GetMaxExportIdByFundAndNAVDate (@FundId VARCHAR(10), @NAVDate DATETIME) AS
BEGIN
SELECT MAX(e.ExportId) FROM    FSFundModel.Reporting.Export e WHERE   e.FundId  = @FundID  AND     e.NAVDate = @NAVDate
END

GO
EXEC sp_addextendedproperty N'VirtualFolder', N'Addin', 'SCHEMA', N'Addin', 'PROCEDURE', N'GetMaxExportIdByFundAndNAVDate', NULL, NULL
GO
